Topic and Research Question

How do units of net housing supply compare across regions of England? Ajusting to regional population.

Data

Import

Wrangle: Net Additional Dwellings data

Plot: Net Additional Dwellings data

Wrangle: Population data

Plot: Population

Wrangle: Merging datasets

Final Plot for Assessment

#plot it all!
plot_merge <- ggplot(data_merge, aes(x = Year, y = Dwell_By_Pop, group = `Region`, colour = `Region`,
                                    text = paste(Region, "|", Year,
                                                 "<br>Population:", format(Population, big.mark = ","),
                                                 "<br>Completed Builds:", format(Net_Additional_Dwellings, big.mark = ","),
                                                 "<br><b>Homes completed per 1000 people:</b>", round(Dwell_By_Pop, 3)))) +
  geom_line() +
  geom_point() +
  labs(title = "New Homes Completed to Population by English Region, 2011-2023", 
       x = "Year",
       y = "New Homes completed per 1000 people") +
  scale_x_continuous(
    breaks = seq(2011, 2023)) +
  scale_y_continuous(
    breaks = seq(1, 5.5, by = 0.5),
      limits = c(1, 5.5))

plot_merge

library(plotly)
## 
## Attaching package: 'plotly'
## The following object is masked from 'package:ggplot2':
## 
##     last_plot
## The following object is masked from 'package:stats':
## 
##     filter
## The following object is masked from 'package:graphics':
## 
##     layout
## Convert ggplot to plotly & ensure custom hover text is shown
plot_interactive_ratio <- ggplotly(plot_merge, tooltip = "text")
  
## Show the interactive plot
plot_interactive_ratio

Conclusions

Limitations & Future ideas

References

All data was extracted from the Office of National Statistics.

Net Additional Dwellings data: Table 118: annual net additional dwellings and components, England and the regions (ODS, 54KB) -
https://www.gov.uk/government/statistical-data-sets/live-tables-on-net-supply-of-housing#live-tables (Updated: 28 November 2024)

Population estimates data: Mid-2023: 2023 local authority boundaries edition of this dataset edition of this dataset (xlsx, 813.1KB) -
https://www.ons.gov.uk/peoplepopulationandcommunity/populationandmigration/populationestimates/datasets/estimatesofthepopulationforenglandandwales (Released: 15 July 2024)